Data Query

Selection

Map

Datatables

Location

Attributes

Boxplot

Information

Dashboard Information:

This dashboard offers an interactive, user-friendly platform for exploring the ISO 28258 domain model, incorporating spatial visualization with data table interaction.

  1. Database Query: Your query filters the soil data stored in PostgreSQL. The filter box utilises crosstalk to create interactive filters that affect both the map and the datatable. This enhances the dashboard’s interactivity by allowing users to filter the displayed data dynamically.

  2. Crosstalk Integration: The application is prepared for interactivity across widgets. This enables filtering actions in one widget to automatically reflect in others.

  3. Interactive Map and DataTable: The map markers use longitude and latitude from the query, and popups display the project name and site code. The points are coloured according to their project name. The DataTable box includes buttons for exporting the data in various formats, enhancing usability.

Tables and Their Relationships

project

  • Description: Contains details about different projects, including their names.
  • Relationships: Each project can be associated with multiple sites.

site

  • Description: Represents specific locations.
  • Relationships: Each site can have multiple plots and is linked to one or more projects through the site_project table.

site_project

  • Description: A junction table that establishes a many-to-many relationship between sites and projects.
  • Relationships: Allows each site to be associated with multiple projects and vice versa.

plot

  • Description: Contains information about specific plots within a site.
  • Relationships: Each plot can contain multiple profiles.

profile

  • Description: Represents a detailed examination or analysis profile within a plot, potentially containing multiple elements.
  • Relationships: Linked to plots and can encompass various elements.

element

  • Description: Details specific elements (or specimens) within a profile, each of which can have multiple results associated with it.
  • Relationships: Associated with profiles and can have multiple analysis results.

result_phys_chem

  • Description: Holds the actual physical and chemical results of analyses performed on elements, including the observation values.
  • Relationships: Linked to elements for which the analyses were conducted.

observation_phys_chem

  • Description: Contains the definitions and labels for different types of physical and chemical observations.
  • Relationships: Defines the parameters for the result_phys_chem records.